LEAVE Statement

This MariaDB tutorial explains how to use the LEAVE statement in MariaDB with syntax and examples.

Description

In MariaDB, the LEAVE statement is used when you want to exit a block of code identified by a label_name, such as a LOOP statement, WHILE statement, or REPEAT statement.

Syntax

The syntax for the LEAVE statement in MariaDB is:

LEAVE label_name;

Parameters or Arguments

label_name

The name of the block of code (ie: LOOP, WHILE, REPEAT) to terminate.

Note

• You use the LEAVE statement to terminate a block of code, such as a LOOP statement, WHILE statement, or REPEAT statement that is identified by a label_name.

Example

Let's look at an example that shows how to use the LEAVE statement in MariaDB:

DELIMITER //

 

CREATE FUNCTION CalcValue ( starting_value INT )

RETURNS INT DETERMINISTIC

 

BEGIN

 

   DECLARE total_value INT;

 

   SET total_value = 0;

 

   label1: LOOP

     SET total_value = total_value + starting_value;

     IF total_value < 999 THEN

       ITERATE label1;

     END IF;

     LEAVE label1;

   END LOOP label1;

 

   RETURN total_value;

 

END; //

 

DELIMITER ;

In this LEAVE example, we have created a loop called label1 using the LOOP statement.

The ITERATE statement would cause the loop to repeat while total_value is less than 999. Once total_value is greater than or equal to 999, the LEAVE statement would terminate the LOOP.